Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_14

R_14

Kinship

Kinship

Kin_KinshipID

 

 

R_25

R_25

Person

Person

Per_PersonID

 

 

R_32

R_32

Dictionary

DictionaryValue

DictionaryID

 

 

R_62

R_62

Accounts

Import

AccountID

 

 

R_70

R_70

Service

LServServ

ServID

 

 

R_88

R_88

Period

NormCost

PeriodID

 

 

R_89

R_89

Service

NormCost

ServID

 

 

R_131

R_131

CostType

SplitResultSum

CostTypeID

 

 

R_132

R_132

Period

SplitResultSum

PeriodID

 

 

R_134

R_134

Address

LOrgUnitAddress

AddressID

 

 

R_135

R_135

Period

Import

PeriodID

 

 

R_147

R_147

PerfService

PerfResource

PerfServiceID

 

 

R_150

R_150

Language

PerfServStatusText

LanguageID

 

 

R_152

R_152

Service

CostServPeriod

ServID

 

 

R_154

R_154

Address

LInsurerAddress

AddressID

 

 

R_159

R_159

Insurer

LInsurerAddress

InsurID

 

 

R_160

R_160

Patient

LPatientInsurer

PersonID

 

 

R_161

R_161

Insurer

LPatientInsurer

InsurID

 

 

R_186

R_186

Service

LOrgUnitServ

ServID

 

 

R_206

R_206

Language

ResourceItemKindText

LanguageID

 

 

R_215

R_215

Service

LServPerfServ

ServID

 

 

R_222

R_222

OrgUnitType

OrgUnitTypeText

OrgUnitTypeID

 

 

R_223

R_223

Language

OrgUnitTypeText

LanguageID

 

 

R_229

R_229

Language

SystemText

LanguageID

 

 

R_249

R_249

Language

StockDocumentTypeText

LanguageID

 

 

R_271

R_271

Language

DrugFormText

LanguageID

 

 

R_278

R_278

Language

PackageText

LanguageID

 

 

R_306

R_306

CostType

Cost

CostTypeID

 

 

R_307

R_307

CostType

CostTypeText

CostTypeID

 

 

R_308

R_308

Language

CostTypeText

LanguageID

 

 

R_315

R_315

ResourceItem

LResourceResource

Res_ResourceID

 

 

R_316

R_316

ResourceItem

LResourceResource

ResourceID

 

 

R_317

R_317

SysMsg

SystemText

SysMsgID

 

 

R_318

R_318

SysMsg

LSysMsgGroup

SysMsgID

 

 

R_319

R_319

SysMsgGroup

LSysMsgGroup

SysMsgGroupID

 

 

R_320

R_320

Service

Cost

ServID

 

 

R_321

R_321

ResourceItem

Cost

ResourceID

 

 

R_331

R_331

ResourceType

ResourceItem

ResourceTypeID

 

 

R_332

R_332

ResourceType

ResourceTypeText

ResourceTypeID

 

 

R_343

R_343

Patient

Episode

PersonID

 

 

R_351

R_351

Language

UserDefinition

LanguageID

 

 

R_352

R_352

UserDefinition

LUserType

PersonID

 

 

R_353

R_353

UserType

LUserType

UserTypeID

 

 

R_354

R_354

UserDefinition

LUserGroup

PersonID

 

 

R_355

R_355

UserGroup

LUserGroup

UserGroupID

 

 

R_356

R_356

UserDefinition

LUserSysFct

PersonID

 

 

R_357

R_357

SysFct

LUserSysFct

SysFctID

 

 

R_358

R_358

UserType

LUserTypeSysMgr

UserTypeID

 

 

R_359

R_359

SysFct

LUserTypeSysMgr

SysFctID

 

 

R_362

R_362

Person

LPersonPerson

Per_PersonID

 

 


2  3